package com.px.baolaiapi.ExcelDto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import com.alibaba.excel.enums.poi.FillPatternTypeEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;

import java.io.Serializable;

@Data
@NoArgsConstructor
@AllArgsConstructor
@HeadStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 3)
// 头字体设置成20
@HeadFontStyle(fontHeightInPoints = 12)
@HeadRowHeight(20)
// 内容字体设置成20
@ContentFontStyle(fontHeightInPoints = 10)
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER)
public class ExcelMaintenanceDto implements Serializable {
    private static final long serialVersionUID = 1L;


    @ExcelProperty(value = "设备编码", index = 0)
    @ColumnWidth(20)
    private String deviceCode;

    @ExcelProperty(value = "设备名称", index = 1)
    @ColumnWidth(20)
    private String deviceName;

    @ExcelProperty(value = "料号", index = 2)
    @ColumnWidth(20)
    private String bomCode;

    @ExcelProperty(value = "品名", index = 3)
    @ColumnWidth(20)
    private String bomName;

    @ExcelProperty(value = "工序编号", index = 4)
    @ColumnWidth(20)
    private String processStepCode;

    @ExcelProperty(value = "工序名称", index = 5)
    @ColumnWidth(20)
    private String processStepName;

    @ExcelProperty(value = "实际工时（分钟）", index = 6)
    @ColumnWidth(20)
    private Float realHours;

    @ExcelProperty(value = "加工数量", index = 7)
    @ColumnWidth(20)
    private Integer processNum;
}
